|
This page last changed on Feb 24, 2009 by mpb6001.
Use available functionality on Oracle 10g
Edit
Professor Hawker had stated there are various providers (ITS, CS dept) for oracle. Personal licenses are available.
Potential issues are:
- Connectivity
- Syntax of queries
- Massive changes required
- JDBC support for metadata information
- Dual database support (need for abstraction)
Priority
|
Description |
Time Estimate
|
Time Remaining
|
Actual Time
|
Last Updated By
|
Status
|
| 1 |
Investigate install options
|
1
|
0
|
.75
|
Chris
|
Completed
|
| 2 |
Install/get connection to a database
|
1
|
0
|
4
|
|
Completed
|
| 3 |
Duplicate/Separate tests into an oracle and MySQL suites |
3
|
|
|
|
Impediment
OracleResultSetMetaData interface does not implement the getSchemaName()
and getTableName() methods because underlying protocol does
not make this feasible.
http://www.engr.mun.ca/~theo/JavaCC-Tutorial/javacc-tutorial.pdf
SELECT syntax - http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10002.htm#SQLRF01702
|
4
|
Run tests and fix errors
|
3 |
|
|
|
Impediment
|
5
|
Issue #3 - IE support
|
1.5
|
0
|
1.5
|
Paul
|
Complete
|
6
|
Issue #8 - ID columns hidden value
|
.75
|
0
|
.75
|
Paul
|
Complete
|
7
|
Issue #4 - Sorting after refresh
|
1.5
|
0
|
1
|
Paul
|
Complete
|
8
|
Issue #7 - Single row update
|
1
|
0
|
.75
|
Paul
|
Complete
|
| 9 |
Issue #15 - Resource paths
|
.75
|
0
|
.75
|
Paul |
Complete
|
10
|
Issue #14 - error handling
|
.5
|
0
|
.25
|
Paul
|
Complete
|
| |
|
|
|
|
|
|
| Total |
|
14
|
0
|
5.75
|
|
|
|
